How to: Add a new worksheet in addition to the 16 default worksheets.
Solution:
Click the sheet tab and select 'Worksheet' from the 'Insert' menu.
NOTE: By default, an Excel workbook has 16 worksheets when the workbook is created. However, a workbook can contain up to 255 worksheets.
To add a new worksheet in addition to the sixteen worksheets:
1) Click sheet tab where a new worksheet will be inserted.
NOTE: To add multiple worksheets at once, press and hold down SHIFT and select the number of tabs corresponding to the number of worksheets to add.
2) Select the 'Insert' menu and select 'Worksheet'.